package com.atguigu.gmallpublisher.mapper;

import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;

/**
 * @className: GmvMapper
 * @author: LinCong
 * @description:
 * @date: 2023/2/18 12:05
 * @version: 1.0
 */

public interface GmvMapper {
    @Select("select sum(order_amount) from dws_trade_province_order_window where toYYYYMMDD(stt)=#{date}")
    Double selectGmv(int date);
}
